package com.ytjj.qmyx.supplychain.mapper.entity;

import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

import javax.persistence.Column;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 商品规格表
 */
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
@Table(name="yx_product_spec")
public class YxProductSpec {
    /**
     * 主键
     */
    @Id
    @GeneratedValue(generator = "JDBC")
    private Integer id;
    /**
     * 商品id
     */
    @Column(name = "product_id")
    private Integer productId;
    /**
     * sku规格json
     */
    @Column(name = "sku_spec")
    private String skuSpec;

    /**
     * 售价
     */
    @Column(name = "price")
    private BigDecimal price;

    /**
     * 直接购买价
     */
    @Column(name = "cur_price")
    private BigDecimal curPrice;

    /**
     * 成本价
     */
    @Column(name = "cost_price")
    private BigDecimal costPrice;

    /**
     * 原价
     */
    @Column(name = "original_price")
    private BigDecimal originalPrice;

    /**
     * 商品图
     */
    @Column(name = "pro_img")
    private String proImg;

    /**
     * 销量
     */
    @Column(name = "buy_sum")
    private Integer buySum;

    /**
     * 库存
     */
    @Column(name = "stock")
    private Integer stock;

    /**
     * 状态
     */
    @Column(name = "status")
    private Integer status;

    /**
     * 创建时间
     */
    @Column(name = "create_time")
    private Date createTime;

    /**
     * 修改时间
     */
    @Column(name = "update_time")
    private Date updateTime;

    /**
     * 供应商商品id
     */
    @Column(name = "banker_product_id")
    private Integer bankerProductId;

    /**
     * 测评库商品id
     */
    @Column(name = "evaluation_product_id")
    private Integer evaluationProductId;

    /**
     * 外部sku-id
     */
    @Column(name = "three_sku_id")
    private String threeSkuId;

    /**
     * 测评库存
     */
    @Column(name = "evaluation_stock")
    private Integer evaluationStock;

    /**
     * 商品条码
     */
    @Column(name = "goods_code")
    private String goodsCode;

    /**
     * 供货价
     */
    @Column(name = "supply_price")
    private BigDecimal supplyPrice;

    /**
     * 建议售价
     */
    @Column(name = "sale_price")
    private BigDecimal salePrice;

    /**
     * 供应商商品规格id
     */
    @Column(name = "supply_id")
    private Integer supplyId;

    /**
     * 市场价
     */
    @Column(name = "market_price")
    private BigDecimal marketPrice;
}
